Querying the database using Schema-free SQL

نویسنده

  • Carlos Rivero
چکیده

Shema-free SQL takes into consideration two relaxations 1. Schema Relaxation: Users need not have to specify the exact name of the tables and attributes • Join Path: users need not have to specify the join path in the query Reducing user workload of writing SQL queries and knowing the complete database schema to query the RDBMS in order to get desired results Generation of Join Network (Interpretation of SQL) Select a single relation tree node as a join network and keep expanding them to create a join network. While expanding I.e. joining nodes with the help of edges, nodes and viewgraphs are taken into consideration. 1. Potential Estimation: For pruning purpose 2. Legality Test: Use of Rightmost Path Expansion to avoid generating isomorphic graphs, i.e. expanding the network(graph) only from the newly added child node to the parent node. 3. Top K MTJN are generated and the corresponding SQL queries are generated

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Object-Oriented Querying of Existing Relational Databases

In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...

متن کامل

Object-Oriented Querying of Existing Relations Databases

In this paper, we present algorithms which allow an object-oriented querying of existing relational databases. Our goal is to provide an improved query interface for relational systems with better query facilities than SQL. This seems to be very important since, in real world applications, relational systems are most commonly used and their dominance will remain in the near future. To overcome ...

متن کامل

Querying Heterogeneous Databases Using Standardized Schemas and SQL

Making databases available for querying both within and across organizations is a vision held by many. Realizing this vision, however, is usually hampered by the existence of heterogeneous database systems, heterogeneous query languages and heterogeneous data semantics. What is needed is a uniform method for accessing these databases. This paper presents a standards based approach in which SQL ...

متن کامل

Cooperative Relational Database Querying Using Multiple Knowledge Bases

Copyright © 1999, American Association for Artificial Intelligence (www.aaai.org). All rights reserved. +On sabbatical leave at University of Florida, IFAS-IT Abstract We present in this paper an approach for providing cooperativeness in database querying using artificial intelligence techniques. The main focus is a cooperative interface that assists non-experienced and casual users in extracti...

متن کامل

Multidatabase Querying by Context

The overwhelming acceptance of the SQL standard [10] has curtailed continuing research work in relational database query languages and processing. Since all commercial relational database systems conform with the SQL standard, there is little motivation for developing new query languages. Despite its benefits and wide-spread acceptance, SQL is not a perfect query language. Complex database sche...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2016